package com.cqut.dao;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;
import org.junit.runners.Parameterized.Parameters;

public interface CompetitionAuditMapperExtra {
	
	long findCountByLimit(
			@Param("competitionName")
			String competitionName,
			@Param("competitionState")
			String competitionState);

	List<Map<String, Object>> findCompetitionAuditsByLimit(
			@Param(value = "competitionName")
			String competitionName,
			@Param("competitionState")
			String competitionState,
			@Param(value = "start")
			int start,
			@Param(value = "end")
			int end);
	List<Map<String, Object>> findCompetitionAuditsWithLimit(
			@Param(value = "competitionName")
			String competitionName,
			@Param(value = "competitionState")
			String competitionState,
			@Param(value = "start")
			int start,
			@Param(value = "end")
			int end);
	int passCompetitions(
			@Param(value = "competitionsIds")
			String[] competitionsIds);
	int retreatCompetitions(
			@Param(value = "competitionsIds")
			String[] competitionsIds);

	Map<String, Object> getDetailById(
			String competitionId);
	
	List<Map<String, Object>> getStates();
	
}
